RetailTransasctionLineItemCalendarPeriodAssociation

Entity Definition

Logical Name : RetailTransasctionLineItemCalendarPeriodAssociation
Physical Name : ETL_DW3_DIM_ST_ASCTN_RTL_TRN_CA

Associative entity that ties retail transaction fact tables (for sales/returns, tender and loyalty points) to a specific calendar based on business day date. The business day date identifies a leaf level calendar period (which corresponds to a calendar day) and enables a transaction line item to be tied to one or more different calendars (where calendar ID is determined by the retailer through a parameter. This approach is required since in ARTS we allow a retailer to establish one or more retail calendars each with their own hierarchy.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint TenderFact(ETL_DW3_FACT_TENDER_BEHAVIOR)
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint CustomerLoyaltyProgramFact(ETL_DW3_FACT_CT_LYLTY_BEHAVIOR)
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) CustomerLoyaltyProgramFact(ETL_DW3_FACT_CT_LYLTY_BEHAVIOR)
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) TenderFact(ETL_DW3_FACT_TENDER_BEHAVIOR)
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) SalesReturnFact(ETL_DW3_FACT_SALE_RTN_BEHAVIOR)
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint SalesReturnFact(ETL_DW3_FACT_SALE_RTN_BEHAVIOR)
CalendarID (FK)(PK) A unique system assigned identifier for the Calendar. ID_CLD Identity int CalendarPeriodHierarchyDimension(ETL_DW3_DIM_CA_HIER)
BusinessDayDate (FK)(PK) The calendar date of the BusinessDay. DC_DY_BSN DateCalendar date CalendarPeriodHierarchyDimension(ETL_DW3_DIM_CA_HIER)

Relationships

Parent Entity Verb Phrase Child Entity
SalesReturnFact occurs during RetailTransasctionLineItemCalendarPeriodAssociation
CalendarPeriodHierarchyDimension designates calendar period for RetailTransasctionLineItemCalendarPeriodAssociation
CustomerLoyaltyProgramFact occurs during RetailTransasctionLineItemCalendarPeriodAssociation
TenderFact occurs during RetailTransasctionLineItemCalendarPeriodAssociation

No Logical Views for RetailTransasctionLineItemCalendarPeriodAssociation